Error: Cannot define custom formats due to no password.
Error:
Error accessing User-defined AutoFormat file
Cause:
This problem occurs because the file XL5GALRY.XLS is saved with password. This file saves all the user-defined formats therefore the correct password must be entered to be able to write to the file.
Solution:
Type the correct password when prompted or remove the password from XL5GALRY.XLS.
1) Open the file XL5GALRY.XLS located in the XLSTART folder:
a) Select the 'File' menu and select 'Open...'. (The Open dialog box appears.)
b) Locate and open the XLSTART folder.
c) Select the file.
d) Click 'Open'. (A dialog box appears prompting for a password.)
e) If the protection password was set:
1] Type the protection password in the 'Password' box.
2] Click 'OK'.
f) If the write-reservation password was set:
1] Type the write-reservation password in the 'Password' box.
2] Click 'OK'. (The file opens.)
2) Select the 'File' menu and select 'Save As...'. (The Save As dialog box appears.)
3) Click 'Options...'. (The Save Options dialog box appears.)
4) Delete the password in the 'Write Reservation Password' box of the 'File Sharing' group.
5) Click 'OK'. (The Save As dialog box reappears.)
6) Locate and open the XLSTART folder.
7) Type the same filename in the 'File name' drop-down list box.
8) Click 'Save' tosave the changes.
9) Select the 'File' menu and select 'Close' to close the file.
